/***********************************************************************************************************************************
 *    Name: CMS_Servers.sql
 *  Author: Frank Figearo — http://www.sqlnerd.me/ — frank@sqlnerd.me
 * Summary: 
 *
 *	Database Engine			0
 *	Analysis Services		1
 *	Reporting Services		2
 *	Integration Services	3
 *	SQL Server Compact		4
 *
**/
USE msdb;

SELECT * FROM  sysmanagement_shared_registered_servers_internal
 WHERE server_type = 2
